Skip to main content

ReplaceData

Properties to make search and replace.

Type

Object

Properties

NameTypeDescription
Whatstringundefined
ReplacementstringThe replacement string.
LookAtXlLookAtSpecifies whether the whole search text or any part of the search text is matched.
SearchOrderXlSearchOrderRange search order - by rows or by columns.
SearchDirectionXlSearchDirectionRange search direction - next match or previous match.
MatchCasebooleanCase sensitive or not. The default value is "false".
ReplaceAllbooleanSpecifies if all the found data will be replaced or not. The default value is "true".